<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Trang mua bán sim số đẹp</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>

<?php require("top.php");?>	
        
    <div class="main">    
		<?php require("menu_left.php"); ?>
            <div class="info">
            	<div class="title_menu" style="font-size: 17px;">
                	Tìm sim nhanh
                </div>
                <div class="content">
                	Hotkey: 
                    <a href="">0912*68</a>, 
                    <a href="">090*888</a>, 
                    <a href="">094*1990</a>,  
                    <a href="">0913*</a>, 
                    <a href="">*6868</a><br /><br />           
                    <form action="index.php" method="post">
					<select name="mang">
                    	<option selected="selected">Chọn mạng di dộng </option>						
						<option value="Viettel">Viettel </option>
						<option value="Mobi">Mobi</option>						
						<option value="Vina">Vina</option>						
						<option value="EVN">EVN </option>
                    </select> <br /><br />
                    Giá từ
                    <input  value="" name="tu" size="10"/>
                    Đến
                    <input  value="" name="den" size="10"/>    
					<input type="submit" name="ok" value="Tìm kiếm" />
					</form>
                </div>
                
                <div class="title_menu" style="font-size: 17px;">
                	Chọn theo loại số
                </div>
                <div class="content">
                	<a href="">Tứ quý - ngũ quý (aaaa - aaaaa)</a><br />
                	<a href="">Lộc phát - phát tài (xx68-xx86)</a><br />
                	<a href="">Taxi - Lập (ab.ab.ab-abc.abc)</a><br />
                	<a href="">Sim gánh - đảo (abc.cba-ab.ba)</a><br />
                	<a href="">Tam hoa - tam quý (aaa)</a><br />
                	<a href="">Sim tiến (2345 - 5678 - 1234)</a><br />
                	<a href="">Sim kép (aa.bb.cc - aa.cc)</a><br />
                	<a href="">Sim năm sinh (199x-8x-9x)</a><br />
                </div>
                
                <div class="title_menu" style="font-size: 17px;">
                	Chọn theo đầu số
                </div>
                <div class="content"><a href="">
                	<img src="Image/viettel.gif" width="150" height="90"/>
 					<img src="Image/mobifone.gif" width="150" height="90"/>
                    <img src="Image/vinaphone.gif" width="150" height="90"/>
                    <img src="Image/logo_vietna_mobile.gif" width="150" height="90"/></a>
                </div>
				<div class="title_menu">Kết quả  </div>
				<div style="background-color:#FFFFFF">
										
										
										<?php
				require("data/conn.php");				
				
				echo"<table border='1' width='100%'>";
				echo"<tr>";
					echo"<td>STT</td>";
					echo"<td>Số sim</td>";
					echo"<td>Mạng</td>";										
					echo"<td>Loại sim</td>";
					echo"<td>Giá tiền</td>";										
												
										
					echo"</tr>";
					
				$sql="select * from simso where  LoaiSim='Dep Ngu Quy'";
				$query=mysql_query($sql);
				if(mysql_num_rows($query) == 0)
				{					
					echo"<tr>";
					echo"<td colspan=6 >Không tồn tại Sim !!</td>";					
					echo"</tr>";
				}else{
					$stt=0;
					while($row=mysql_fetch_assoc($query)){
							$stt ++;
							echo"<tr>";	
							echo"<td>$stt</td>";							
							echo"<td>$row[SoSim]</td>";
							echo"<td>$row[TenMang]</td>";
							echo"<td>$row[LoaiSim]</td>";
							echo"<td>$row[GiaTien]</td>";
							
							/*echo "<td>$row[GiaTien]</td>" ;
`							echo"<td>$row[GhiChu]</td>";	*/							
							echo"</tr>";
							}					
						
						}
							echo"</table>";						
					
				
				mysql_close($conn);
				?>		
									
						
				</div>
            </div>        
        <?php require("menu_right.php"); ?>
    </div>
    
<?php require("bottom.php");?>	